USE [LAFDC]
GO
/****** Object:  Trigger [dbo].[tr_AdherentCreateDate]    Script Date: 11/23/2009 23:08:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[tr_AdherentCreateDate] ON [dbo].[Adherent]
FOR INSERT
AS
UPDATE [Adherent] SET [Adherent].Created=getdate()
FROM [Adherent] INNER JOIN Inserted ON [Adherent].[Prev_Id]= Inserted.[Prev_Id]
